Release 10.1A: OpenEdge Data Management:
SQL Development

Creating users

Use the following syntax to employ the CREATE USER statement:

Syntax

CREATE USER 'username', 'password' ;

In Example 4–1, an account with DBA privileges creates the 'username' 'GPS' with 'password' 'star'.

Example 4–1: CREATE USER statement

CREATE USER 'GPS', 'star';

A user’s password can be changed easily by using the ALTER USER statement:

Syntax

ALTER USER 'username', 'old_password', 'new_password';

Example 4–2 demonstrates the use of the ALTER USER statement.

Example 4–2: ALTER USER statement

ALTER USER 'GPS', 'star', 'star1';

When users are created, the default DBA (the user who created the database) becomes disabled. It is important to grant DBA access to at least one user so you will have a valid DBA account. The user’s password can be easily changed using the ALTER USER statement.

For complete details on the CREATE USER statement, see OpenEdge Data Management: SQL Reference .